XLSX EXPORT Problem

lorenzoblorenzob
edited 11:46AM in FastReport VCL 5
A client of mine pointed out to me that export XLSX suffers from a strange bug.
If data is formatted as a number with decimals, then the number appears in Excel multiplied by 10 raised to the number of decimal places used.
Eg: format =% 0.2f then the number is multiplied by 100!
If I remove the number formatting and put format as text then it works!
Any idea?
The program is compiled with Delphi XE3, FastReport 5.4

thanks
Lorenzo

Comments

  • gpigpi
    edited 11:46AM
    See changes.txt
    wrote:
    5.4.2
    - Fixed numeric formatting in the XLSX export
  • lorenzoblorenzob
    edited 11:46AM
    gpi wrote: »
    See changes.txt
    gpi wrote: »
    5.4.2
    - Fixed numeric formatting in the XLSX export

    Usually I install only the "release" versions so I will wait for the next!
    Thanks so much for the information! >

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2024